ADVANCE EXCEL 2010 with Farmula , Excel Tips and Tricks.
(HB4)
Duration: 1-DVD
SYLLABUS:Complete List of Tutorials for Excel 1. Converting, Copying Formulas
2. Vlook Up
3. Choose Index, Match
4. Count if, Sum if, Average if
5. Rank, Median, Average
6. Date, Time Weekday, Workday
7. Array, Frequency
8. Find Data Extract, Left, Right
9. Replace, Substitute, Concatenate, Upper, Lower
10. Pmt and Fv
11. Is Function
12. Offset, Data Extract
Excel Formula - Tips and Tricks
1. Count, Count Blank, Count if
2. Dated if, Abs, Average
3. Edate, Len
4. Large, Sum Product
5. Power, Rand Between
6. Repeat, Find
7. Round, Fixed
8. Small, Roman and
9. Time, Trim, Year, Today, Now
|